When using SAS/ACCESS Interface to ODBC, you might receive an error similar to the following:

The problem occurs under the following conditions:

• You use SAS/ACCESS^® Interface to ODBC to connect to Microsoft SQL Server.
• You set BULKLOAD=YES. 
• You use a Microsoft Windows 10 operating system.

This problem occurs because the following ODBC driver versions have problems with bulk loading:

• the version 10 driver (typically, it is version 10.0.14393.0 or a similar number)
• the version 13 driver (typically, it is version 2015.131.4413.46 or a similar number)

To circumvent the problem, do one of the following:

• Upgrade to SAS^® 9.4M5 (TS1M5) of the SAS system and install the latest Microsoft SQL Server Native Client 13 driver.
• Use the INSERTBUFF= option in your LIBNAME statement instead of BULKLOAD=.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS/ACCESS Interface to ODBC	Microsoft® Windows® for x64	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Microsoft Windows 8 Enterprise x64	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Microsoft Windows 8 Pro x64	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Microsoft Windows 8.1 Enterprise 32-bit	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Microsoft Windows 8.1 Enterprise x64	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Microsoft Windows 8.1 Pro 32-bit	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Microsoft Windows 8.1 Pro x64	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Microsoft Windows 10	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Microsoft Windows Server 2008 R2	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Microsoft Windows Server 2008 for x64	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Microsoft Windows Server 2012 Datacenter	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Microsoft Windows Server 2012 R2 Datacenter	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Microsoft Windows Server 2012 R2 Std	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Microsoft Windows Server 2012 Std	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Windows 7 Enterprise x64	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5
		Windows 7 Professional x64	9.4	9.4_M5	9.4 TS1M0	9.4 TS1M5

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

The "BRIDGE FAILURE..." error can occur when you use SAS/ACCESS® Interface to ODBC with bulk loading on Windows 10. The problem occurs with the default version 10 and 13 drivers. To circumvent the problem, install the latest Microsoft SQL Server Native Client 11.0 drivers.

Type:	Usage Note
Priority:

Date Modified:	2017-05-16 13:41:12
Date Created:	2017-05-10 12:51:24